const Koa = require('koa')
const app = new Koa()
const views = require('koa-views')
const json = require('koa-json')
const onerror = require('koa-onerror')
const bodyparser = require('koa-bodyparser')
const logger = require('koa-logger')

const index = require('./routes/index')
const users = require('./routes/users')
const menus = require('./routes/menus')
const roles = require('./routes/roles')
const rolesMenu = require('./routes/rolesMenu')
const flexiPageTemplates = require('./routes/flexiPage/templates')
const flexiPageTemplatesCategory = require('./routes/flexiPage/templatesCategory')


// 汉字
const hanziRouter = require('./modules/hanzi/routers')

// const mysql = require('mysql2/promise')

// MySQL 配置
// const dbConfig = {
//   host: 'localhost',
//   port: 3306,
//   user: 'root',
//   password: '123456',
//   database: 'digitalpresencedatacore',
// }

// let pool
// ;(async () => {
//   pool = await mysql.createPool(dbConfig)
// })()

// error handler
onerror(app)

// middlewares
app.use(
  bodyparser({
    enableTypes: ['json', 'form', 'text'],
  })
)
app.use(json())
app.use(logger())
app.use(require('koa-static')(__dirname + '/public'))

app.use(
  views(__dirname + '/views', {
    extension: 'pug',
  })
)

// logger
app.use(async (ctx, next) => {
  // const pool = await mysql.createPool(dbConfig)
  // ctx.state.db = pool
  await next()
  const start = new Date()
  const ms = new Date() - start
  console.log(`${ctx.method} ${ctx.url} - ${ms}ms`)
})

// routes
app.use(index.routes(), index.allowedMethods())
app.use(users.routes(), users.allowedMethods())
app.use(menus.routes(), menus.allowedMethods())
app.use(roles.routes(), roles.allowedMethods())
app.use(rolesMenu.routes(), rolesMenu.allowedMethods())

// FlexiPage
app.use(flexiPageTemplates.routes(), flexiPageTemplates.allowedMethods())
app.use(flexiPageTemplatesCategory.routes(), flexiPageTemplates.allowedMethods())

// 汉字模块
app.use(hanziRouter.routes(), hanziRouter.allowedMethods())

// error-handling
app.on('error', (err, ctx) => {
  console.error('server error', err, ctx)
})

module.exports = app
